﻿CREATE TABLE [dbo].[ServiceRequest] (
    [Id_ServiceRequest] INT           IDENTITY (1, 1) NOT NULL,
    [SR_Number]         VARCHAR (10)  NULL,
    [Name]              VARCHAR (50)  NULL,
    [SR_Description]    VARCHAR (500) NULL,
    [Id_Project]        INT           NULL,
    [SR_Date]           SMALLDATETIME NOT NULL,
    [Id_User]           INT           NULL,
    [Status]            VARCHAR (10)  NULL,
    PRIMARY KEY CLUSTERED ([Id_ServiceRequest] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

